-- phpMyAdmin SQL Dump
-- version 2.9.2
-- http://www.phpmyadmin.net
-- 
-- Serveur: localhost
-- Gnr le : Vendredi 20 Juin 2008  16:28
-- Version du serveur: 5.0.27
-- Version de PHP: 5.2.1
-- 
-- Base de donnes: `test`
-- 

-- --------------------------------------------------------

-- 
-- Structure de la table `admin`
-- 

CREATE TABLE `admin` (
  `id` int(4) NOT NULL auto_increment,
  `username` varchar(65) NOT NULL default '',
  `password` varchar(65) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

-- 
-- Contenu de la table `admin`
-- 

INSERT INTO `admin` VALUES (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e');

-- --------------------------------------------------------

-- 
-- Structure de la table `book`
-- 

CREATE TABLE `book` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(80) NOT NULL,
  `autor` varchar(80) NOT NULL,
  `date` varchar(80) NOT NULL,
  `lien` varchar(250) NOT NULL,
  `description` varchar(800) NOT NULL,
  `category` varchar(580) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Contenu de la table `book`
-- 


-- --------------------------------------------------------

-- 
-- Structure de la table `client`
-- 

CREATE TABLE `client` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(80) NOT NULL,
  `autor` varchar(80) NOT NULL,
  `date` varchar(80) NOT NULL,
  `lien` varchar(250) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Contenu de la table `client`
-- 


-- --------------------------------------------------------

-- 
-- Structure de la table `pro`
-- 

CREATE TABLE `pro` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(80) NOT NULL,
  `autor` varchar(80) NOT NULL,
  `lien` varchar(250) NOT NULL,
  `description` varchar(800) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Contenu de la table `pro`
-- 


-- --------------------------------------------------------

-- 
-- Structure de la table `ser`
-- 

CREATE TABLE `ser` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(80) NOT NULL,
  `autor` varchar(80) NOT NULL,
  `lien` varchar(250) NOT NULL,
  `description` varchar(800) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Contenu de la table `ser`
-- 


-- --------------------------------------------------------

-- 
-- Structure de la table `setting`
-- 

CREATE TABLE `setting` (
  `category` varchar(50) NOT NULL,
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Contenu de la table `setting`
-- 

